pointing to the wrong DB
-
hi, i'm new in this. i've been doing a prgm using vb.net with asp.net and it's working when i run it in my local pc. but, when i deploy it to my server the database r pointing to my local pc. i've check my web config and my coding. but all are written to point to the server dbase. i know it's pointing to my local pc bcoz i rename my DB in the local pc. so when i run at the server, the prgm told me my table name is invalid eventhough the table r there at the server. but when i rename my DB at the local pc ti it's original name, the prgm shows all the data from my local DB. it can add data but to my local DB. help me pls.. this is my first time doing a prgm..
-
This is a re-post.
Shhhhh..... http://craptasticnation.blogspot.com/[^]
To be fair, I told him he was in the wrong forum and it belonged here.
Christian Graus Please read this if you don't understand the answer I've given you "also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
-
To be fair, I told him he was in the wrong forum and it belonged here.
Christian Graus Please read this if you don't understand the answer I've given you "also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
yup, b4 this i'm in the wrong forum. and it's not him, it's her... :) where to know the mistake if i try to debug and there's a massage say cannot debug bcoz windows authenthication is disable. but the prgm can run without debug and there's no problem with it.
-
yup, b4 this i'm in the wrong forum. and it's not him, it's her... :) where to know the mistake if i try to debug and there's a massage say cannot debug bcoz windows authenthication is disable. but the prgm can run without debug and there's no problem with it.
<?xml version="1.0" encoding="utf-8"?> <configuration> <appSettings> <add key="strConn" value="data source=MISKPI;User ID=sysadm;Password=sysadm;Initial Catalog=SPGALatihan;Persist Security Info=True;"/> </appSettings> <system.web> <!-- DYNAMIC DEBUG COMPILATION Set compilation debug="true" to insert debugging symbols (.pdb information) into the compiled page. Because this creates a larger file that executes more slowly, you should set this value to true only when debugging and to false at all other times. For more information, refer to the documentation about debugging ASP.NET files. --> <compilation defaultLanguage="vb" debug="true"><assemblies><add assembly="CrystalDecisions.CrystalReports.Engine, Version=9.1.5000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"/><add assembly="CrystalDecisions.ReportSource, Version=9.1.5000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"/><add assembly="CrystalDecisions.Shared, Version=9.1.5000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"/><add assembly="CrystalDecisions.Web, Version=9.1.5000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"/></assemblies></compilation> <!-- CUSTOM ERROR MESSAGES Set customErrors mode="On" or "RemoteOnly" to enable custom error messages, "Off" to disable. Add <error> tags for each of the errors you want to handle. "On" Always display custom (friendly) messages. "Off" Always display detailed ASP.NET error information. "RemoteOnly" Display custom (friendly) messages only to users not running on the local Web server. This setting is recommended for security purposes, so that you do not display application detail information to remote clients. --> <customErrors mode="RemoteOnly"/> <!-- AUTHENTICATION This section sets the authentication policies of the application. Possible modes are "Windows", "Forms", "Passport" and "None" "None" No authentication is performed. "Windows" IIS performs authentication (Basic, Digest, or Integrated Windows) according to its settings for the application. Anonymous access must be disabled in IIS. "Forms" You provide a custom form (Web page) for users to enter their credentials, and then you authen
-
<?xml version="1.0" encoding="utf-8"?> <configuration> <appSettings> <add key="strConn" value="data source=MISKPI;User ID=sysadm;Password=sysadm;Initial Catalog=SPGALatihan;Persist Security Info=True;"/> </appSettings> <system.web> <!-- DYNAMIC DEBUG COMPILATION Set compilation debug="true" to insert debugging symbols (.pdb information) into the compiled page. Because this creates a larger file that executes more slowly, you should set this value to true only when debugging and to false at all other times. For more information, refer to the documentation about debugging ASP.NET files. --> <compilation defaultLanguage="vb" debug="true"><assemblies><add assembly="CrystalDecisions.CrystalReports.Engine, Version=9.1.5000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"/><add assembly="CrystalDecisions.ReportSource, Version=9.1.5000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"/><add assembly="CrystalDecisions.Shared, Version=9.1.5000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"/><add assembly="CrystalDecisions.Web, Version=9.1.5000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"/></assemblies></compilation> <!-- CUSTOM ERROR MESSAGES Set customErrors mode="On" or "RemoteOnly" to enable custom error messages, "Off" to disable. Add <error> tags for each of the errors you want to handle. "On" Always display custom (friendly) messages. "Off" Always display detailed ASP.NET error information. "RemoteOnly" Display custom (friendly) messages only to users not running on the local Web server. This setting is recommended for security purposes, so that you do not display application detail information to remote clients. --> <customErrors mode="RemoteOnly"/> <!-- AUTHENTICATION This section sets the authentication policies of the application. Possible modes are "Windows", "Forms", "Passport" and "None" "None" No authentication is performed. "Windows" IIS performs authentication (Basic, Digest, or Integrated Windows) according to its settings for the application. Anonymous access must be disabled in IIS. "Forms" You provide a custom form (Web page) for users to enter their credentials, and then you authen
zaimah wrote:
data source=MISKPI
To point to a machine on the network, you need a network path.
Christian Graus Please read this if you don't understand the answer I've given you "also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
-
zaimah wrote:
data source=MISKPI
To point to a machine on the network, you need a network path.
Christian Graus Please read this if you don't understand the answer I've given you "also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
-
I think you're very lost, this is your first program you say ? Are you working in a class, or at home ? You're surely not getting paid ? The path across your network to the SQL Server that is not on your machine.
Christian Graus Please read this if you don't understand the answer I've given you "also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
-
I think you're very lost, this is your first program you say ? Are you working in a class, or at home ? You're surely not getting paid ? The path across your network to the SQL Server that is not on your machine.
Christian Graus Please read this if you don't understand the answer I've given you "also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
At my office. Actually i'm a new worker. My main job is to give a training to our customer how to use our companys system. but my leader ask me to do a web app to record all the calls from our customer so he can trace all the problem that our cistomer had. thank god i can make it n 2 month, but now the problem is only with connection to DB. rite now it can update and add data to my server DB but, i cannot display all the data in data grid bcoz it's only gonna display data from local DB. this is getting weird. and sorry to disturb u with this stupid question.
-
At my office. Actually i'm a new worker. My main job is to give a training to our customer how to use our companys system. but my leader ask me to do a web app to record all the calls from our customer so he can trace all the problem that our cistomer had. thank god i can make it n 2 month, but now the problem is only with connection to DB. rite now it can update and add data to my server DB but, i cannot display all the data in data grid bcoz it's only gonna display data from local DB. this is getting weird. and sorry to disturb u with this stupid question.
zaimah wrote:
but my leader ask me to do a web app to record all the calls from our customer so he can trace all the problem that our cistomer had.
OK, your work does not sound very fair.
zaimah wrote:
and sorry to disturb u with this stupid question.
Oh, I am glad to help you, don't worry about that. I am just trying to understand your situation. A network path is like \\networkmachine\databasename. Just the db name is not going to find it, I don't think.
Christian Graus Please read this if you don't understand the answer I've given you "also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
-
zaimah wrote:
but my leader ask me to do a web app to record all the calls from our customer so he can trace all the problem that our cistomer had.
OK, your work does not sound very fair.
zaimah wrote:
and sorry to disturb u with this stupid question.
Oh, I am glad to help you, don't worry about that. I am just trying to understand your situation. A network path is like \\networkmachine\databasename. Just the db name is not going to find it, I don't think.
Christian Graus Please read this if you don't understand the answer I've given you "also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
-
another question is, i cannot debug my prgm bcoz it say the windows authentication r disable. why is this happening? when i run it without debug, there's no error come out from the prgm.
-
For goodness sakes, buy a book. We're trying to help, but you're lacking even the basic skills to understand our answers.
Christian Graus Please read this if you don't understand the answer I've given you "also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )