Hello all,
This is my first vb6 application...
I'm using Microsoft SQL server 2000 as my back end and vb6 as my front end. My application complies without any problems and i am connecting to my database. However, when i create an executable and try logging in, i'm getting the following error: Error No. -2147467259, [DBNETLIB][ConnectionOpen(Connect()).]SQL Server does not exist or access denied.

Has anyone every had this error before?
Any suggesstions would be appreciated.

Thanks

Hi there...

Did this happens when you try to connect on a different pc, not the one that you use to build and test this app.?

probably, the string connection you are using is bad for that pc.

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========
I know that CVS was evil, and now i got the proof:
http://worsethanfailure.com/Articles...-Hate-You.aspx
================================================== =========

Hi Gonzalo,
Thank you for replying. I get the error message even on my machine, which is the one used to create the executable.

I'm really at a loss with this issue.

Well, you said that you can connect to the database, but from where???

Are you sure that you connection string is ok??

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========
I know that CVS was evil, and now i got the proof:
http://worsethanfailure.com/Articles...-Hate-You.aspx
================================================== =========

Afternoon Gonzalo,
I can connect from my machine to the server (if's that's what you mean); when i step through my program and hover over the connection string, i can see the connection info. Also, there are forms that update various tables in my database, these function fine. If i make an entry and check the table afterwards, the data is there. So, in my mind the application is connecting to the server. Am i correct?

ok, sounds fine, but do you change the connection string when you change the pc?

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========
I know that CVS was evil, and now i got the proof:
http://worsethanfailure.com/Articles...-Hate-You.aspx
================================================== =========

Afternoon again,
No the connection string is not changed on another PC.

Well, I'm almost sure that you have to change the connection string to make it work.

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========
I know that CVS was evil, and now i got the proof:
http://worsethanfailure.com/Articles...-Hate-You.aspx
================================================== =========

Hi Gonzalo,
I got the problem fixed:). After stepping through the program again, we realized that the program was not picking up the .ini (config file) which stores the database name and server name. Added to that, the Executable and the Config file had different names. I think VB has issues with this. Therefore, we just created a new project and pulled all the forms into it, giving the config file and the project the same name and the executable worked:D, that solved all the problems.
Thankyou for your guidance nonetheless.

Jade