Recent content by JayT

It's getting better!!! I read your article, it's helpful. I'm going to give the solution you suggested a try. I'll come back with update :) And just in case anyone looking at this post and wonder of how to get the ip address of the SQL server (in my case), use the [PING] command line. See the...

Banana, thanks for your quick response. The solution looks promising. However, I need a way to create odbc connection so that user can create his/her own query within the access database. The solution you suggested requires the sql statement within the module?:confused:

Hi, I have a module that create the system DSN (odbc) and it works. Now i need to modify this module to add a server Alias with port number for a connection to SQL Server. I searched all over the internet but found nothing regarding the option for port number and server alias. I tried adding...